#ifndef _GAMEDB_H_
#define _GAMEDB_H_


#include "gameDefine.h"
#include "dbDataBase.h"


const fint32 MAX_SQL_BUFFER = 512;
static fbyte SQL_BUFFER[ MAX_SQL_BUFFER ];



static string SQL_INSERT_NEW			=  "CALL SQL_INSERT_NEW(\'%s\', \'%s\' , \'%s\');";
static string SQL_INSERT_ROLE			=  "CALL SQL_INSERT_ROLE(\'%s\', \'%s\' , \'%s\');";


static string SQL_SELECT_ROLES			=  "CALL SQL_SELECT_ROLES();";


static string SQL_SELECT_ACCOUNT_INFO	=  "CALL SQL_SELECT_ACCOUNT_INFO(\'%s\' , \'%s\');";
static string SQL_SELECT_ROLE_INFO		=  "CALL SQL_SELECT_ROLE_INFO(\'%s\');";
static string SQL_SELECT_PET_INFO		=  "CALL SQL_SELECT_PET_INFO(\'%d\');";
static string SQL_INSERT_PET			=  "CALL SQL_INSERT_PET(\'%d\' , \'%s\');";
static string SQL_DELETE_PET			=  "CALL SQL_DELETE_PET(\'%d\');";


static string SQL_UPDATE_QUITGAME		=  "CALL SQL_UPDATE_QUIT_GAME(\'%d\' , \'%s\' , \'%s\');";

static string SQL_UPDATE_PET			=  "CALL SQL_UPDATE_PET(\'%d\' , \'%s\' , \'%s\' );";

static string SQL_DB_QUIT				=  "CALL SQL_DB_QUIT();";



#endif

